/*
 Navicat Premium Data Transfer

 Source Server         : localhost
 Source Server Type    : MySQL
 Source Server Version : 50624
 Source Host           : localhost
 Source Database       : jspz

 Target Server Type    : MySQL
 Target Server Version : 50624
 File Encoding         : utf-8

 Date: 10/07/2016 10:49:49 AM
*/

SET NAMES utf8;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
--  Table structure for `order`
-- ----------------------------
DROP TABLE IF EXISTS `order`;
CREATE TABLE `order` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `service_type` int(11) DEFAULT NULL COMMENT '1.纯外资 2.中外合资',
  `service_way` int(11) DEFAULT NULL COMMENT '1.注册 2.并购',
  `area` varchar(20) DEFAULT NULL,
  `create_at` datetime DEFAULT NULL,
  `product_id` int(11) DEFAULT NULL,
  `user_id` int(11) DEFAULT NULL,
  `update_at` datetime DEFAULT NULL,
  `status` int(11) DEFAULT NULL COMMENT '1.创建填写类型等 2.选完服务人员待支付 3.支付完成',
  `waiter_id` int(11) DEFAULT NULL,
  `product_price` float DEFAULT NULL,
  `waiter_price` float DEFAULT NULL,
  `total_price` float DEFAULT NULL,
  `ordcode` varchar(100) DEFAULT NULL COMMENT '订单编号',
  `payment_trade_no` varchar(100) DEFAULT NULL,
  `payment_notify_id` varchar(100) DEFAULT NULL,
  `payment_notify_status` varchar(100) DEFAULT NULL,
  `payment_notify_time` datetime DEFAULT NULL,
  `payment_buyer_email` varchar(100) DEFAULT NULL,
  `product_name` varchar(100) DEFAULT NULL,
  `waiter_name` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `order`
-- ----------------------------
BEGIN;
INSERT INTO `order` VALUES ('1', '2', '1', '', '2016-09-28 12:56:26', '1', '2', '2016-09-28 12:56:32', '2', '2', null, null, null, null, null, null, null, null, null, null, null), ('2', '1', '1', '', '2016-09-28 01:04:30', '1', '2', '2016-09-28 01:04:32', '2', '2', null, '1000', '1000', null, null, null, null, null, null, null, null), ('3', '1', '1', '', '2016-09-28 01:04:30', '1', '2', '2016-09-28 01:07:04', '2', '2', null, '1000', '1000', null, null, null, null, null, null, null, null), ('4', '1', '1', '', '2016-09-28 01:32:16', '1', '2', '2016-09-28 01:32:19', '2', '2', '2800', '1000', '3800', null, null, null, null, null, null, null, null), ('5', '1', '1', '', '2016-09-30 02:56:52', '1', '2', '2016-09-30 02:56:56', '2', '1', '2800', '588', '3388', '78861752', null, null, null, null, null, null, null), ('6', '1', '2', '广州', '2016-09-30 03:10:49', '1', '2', '2016-09-30 03:10:51', '2', '1', '2800', '588', '3388', '22618325', null, null, null, null, null, '融资租赁', '杜俊平'), ('7', '1', '1', '', '2016-10-04 01:41:55', '1', '2', '2016-10-04 01:41:59', '2', '2', '2800', '1000', '3800', '68799443', null, null, null, null, null, '融资租赁', '吴龙熙'), ('8', '1', '1', '', '2016-10-04 01:42:34', '1', '2', '2016-10-04 01:42:36', '2', '1', '2800', '588', '3388', '51841426', null, null, null, null, null, '融资租赁', '杜俊平'), ('9', '1', '1', '长沙', '2016-10-06 10:30:42', '1', '2', '2016-10-06 10:30:47', '2', '3', '0', '0', '0', '82106017', null, null, null, null, null, '融资租赁', '测试');
COMMIT;

-- ----------------------------
--  Table structure for `product`
-- ----------------------------
DROP TABLE IF EXISTS `product`;
CREATE TABLE `product` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `create_at` datetime DEFAULT NULL,
  `update_at` datetime DEFAULT NULL,
  `pic` varchar(255) DEFAULT NULL,
  `service_name` varchar(200) DEFAULT NULL,
  `summary` varchar(200) DEFAULT NULL,
  `fast_price` float DEFAULT NULL COMMENT '极速价 单位万',
  `pre_price` float DEFAULT NULL COMMENT '单位元',
  `market_price` float DEFAULT NULL COMMENT '市场价 单位万',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `product`
-- ----------------------------
BEGIN;
INSERT INTO `product` VALUES ('1', '融资租赁', '2016-09-19 00:41:23', null, null, '租赁有限责任公司注册', '提交材料，为你注册公司', '28', '0.01', '31'), ('2', '商业保理', '2016-09-19 00:41:37', null, null, '保理有限责任公司注册', '提交材料，为你注册公司', '28', '2800', '31'), ('3', '金融信息服务', '2016-09-19 00:42:06', null, null, '金融信息有限责任公司注册', '提交材料，为你注册公司', '28', '2800', '31'), ('4', '资产管理', '2016-09-19 00:42:23', null, null, '资产管理有限责任公司注册', '提交材料，为你注册公司', '28', '2800', '31'), ('5', '担保', '2016-09-19 00:42:37', null, null, '担保有限责任公司注册', '提交材料，为你注册公司', '28', '2800', '31'), ('6', '小额贷款', '2016-09-19 00:42:47', null, null, '小额有限责任公司注册', '提交材料，为你注册公司', '28', '2800', '31'), ('7', '典当', '2016-09-19 00:43:01', null, null, '典当有限责任公司注册', '提交材料，为你注册公司', '28', '2800', '31');
COMMIT;

-- ----------------------------
--  Table structure for `users`
-- ----------------------------
DROP TABLE IF EXISTS `users`;
CREATE TABLE `users` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(200) NOT NULL,
  `email` varchar(200) DEFAULT NULL,
  `password` varchar(200) DEFAULT NULL,
  `phone` varchar(20) DEFAULT NULL,
  `create_at` datetime DEFAULT NULL,
  `update_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `users`
-- ----------------------------
BEGIN;
INSERT INTO `users` VALUES ('2', '薛腾飞', null, 'afdd0b4ad2ec172c586e2150770fbf9e', '18511013273', '2016-09-27 12:39:47', null);
COMMIT;

-- ----------------------------
--  Table structure for `waiter`
-- ----------------------------
DROP TABLE IF EXISTS `waiter`;
CREATE TABLE `waiter` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(100) NOT NULL,
  `firm` varchar(200) DEFAULT NULL,
  `price` float DEFAULT NULL,
  `area` varchar(100) DEFAULT NULL,
  `pic` varchar(200) DEFAULT NULL,
  `work_age` int(11) DEFAULT NULL,
  `create_at` datetime DEFAULT NULL,
  `update_at` datetime DEFAULT NULL,
  `title` varchar(20) DEFAULT NULL COMMENT '职称',
  `phone` varchar(20) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `waiter`
-- ----------------------------
BEGIN;
INSERT INTO `waiter` VALUES ('1', '杜俊平', '前海俱乐部', '588', '上海', 'Image/waiter/dujunping.png', '3', '2016-09-27 23:16:07', null, '市场部副总经理', '18664922008'), ('2', '吴龙熙', '前海俱乐部', '1000', '上海-浦东', 'Image/waiter/wulongxi.png', '4', '2016-09-27 23:18:12', null, '拓展部副总经理', '18520875157'), ('3', '测试', '前海俱乐部', '0.01', '上海-浦东', 'Image/waiter/wulongxi.png', '2', '2016-10-06 10:28:38', null, '职员', '18888888888');
COMMIT;

-- ----------------------------
--  Table structure for `waiter_product`
-- ----------------------------
DROP TABLE IF EXISTS `waiter_product`;
CREATE TABLE `waiter_product` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `waiter_id` int(11) DEFAULT NULL,
  `product_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `waiter_product`
-- ----------------------------
BEGIN;
INSERT INTO `waiter_product` VALUES ('1', '1', '1'), ('2', '1', '2'), ('3', '1', '3'), ('4', '1', '4'), ('5', '1', '5'), ('6', '2', '6'), ('7', '1', '6'), ('8', '1', '7'), ('9', '2', '1'), ('10', '2', '3'), ('11', '3', '1');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
